Even campaigns that do present gods as foes, such as Icewind Dale: Rime of the Frostmaiden, tend to have mitigating circumstances weakening the god's powers.

Source: https://www.cbr.com/dnd-5e-vecna-lore-stats-history/

Players are adventurers curious about a job offered by Master Peddywinkle, a rich merchant about to set off to Icewind Dale who first needs assistance regarding a mysterious matter, which turns out to be a sinister plot they have to stop no matter what.

Source: https://gamerant.com/dungeons-dragons-honor-among-thieves-best-modules-forgotten-realms/

We do multiple ventures in Icewind Dale, our current module setting going through the Underdark.

Source: https://www.cbr.com/neverwinter-forgotton-realms-ed-greenwood-brett-norton-interview/